Thumb

Introduction to Having Clause

9/14/2020 6:50:53 AM

Introduction to Having Clause: The having clause works as a filter on top of grouped rows returned by the group by clause. This clause cannot be replaced by a where clause and vice-verse. Now given bellow the code example:

select Salary.Gendar, count(*) from Salary group by Salary.Gendar Having Sum(Salary)>20000